Data Profiling Report

Dataset statistics

Number of variables	16
Number of observations	9974
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.9 MiB
Average record size in memory	518.5 B

Variable types

Text	4
DateTime	1
Numeric	9
Categorical	2

Alerts

`energy` is highly overall correlated with `loudness`	High correlation
`loudness` is highly overall correlated with `energy`	High correlation
`tempo` is highly overall correlated with `time_signature`	High correlation
`time_signature` is highly overall correlated with `tempo`	High correlation
`time_signature` is highly imbalanced (74.5%)	Imbalance
`song_id` has unique values	Unique
`key` has 1198 (12.0%) zeros	Zeros
`instrumentalness` has 2102 (21.1%) zeros	Zeros

Reproduction

Analysis started	2024-12-17 03:22:02.277568
Analysis finished	2024-12-17 03:22:13.343971
Duration	11.07 seconds
Software version	ydata-profiling vv4.12.1
Download configuration	config.json

song_id
Text

Unique

Distinct	9974
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	769.6 KiB

Length

Max length	22
Median length	22
Mean length	22
Min length	22

Characters and Unicode

Total characters	219428
Distinct characters	62
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9974 ?
Unique (%)	100.0%

Sample

1st row	57Pk2GU0ABFYBbbcgYxqki
2nd row	6WzRpISELf3YglGAh7TXcG
3rd row	6z3HAUZpAyJ0ctsbAwAiw3
4th row	6uFn47ACjqYkc0jADwEdj1
5th row	4GssB27iJeqmfGxS94Tfij

Value	Count	Frequency (%)
57pk2gu0abfybbbcgyxqki	1	< 0.1%
79s5xncn4tjktvmsmox8ep	1	< 0.1%
3cijedprufiku5tdxey7aw	1	< 0.1%
5zd9tgduwbffxwgnm3k3rz	1	< 0.1%
6z3hauzpayj0ctsbawaiw3	1	< 0.1%
6ufn47acjqykc0jadwedj1	1	< 0.1%
4gssb27ijeqmfgxs94tfij	1	< 0.1%
4myfsmx2v6zndojfn3ikbd	1	< 0.1%
6avihku3ydzaepbmzei62v	1	< 0.1%
3wn8noygkhluq9dlxm1rkw	1	< 0.1%
Other values (9964)	9964	99.9%

Most occurring characters

Value	Count	Frequency (%)
5	4758	2.2%
3	4703	2.1%
2	4676	2.1%
0	4673	2.1%
4	4621	2.1%
1	4595	2.1%
6	4558	2.1%
7	4402	2.0%
z	3521	1.6%
F	3477	1.6%
Other values (52)	175444	80.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	219428	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
5	4758	2.2%
3	4703	2.1%
2	4676	2.1%
0	4673	2.1%
4	4621	2.1%
1	4595	2.1%
6	4558	2.1%
7	4402	2.0%
z	3521	1.6%
F	3477	1.6%
Other values (52)	175444	80.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	219428	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
5	4758	2.2%
3	4703	2.1%
2	4676	2.1%
0	4673	2.1%
4	4621	2.1%
1	4595	2.1%
6	4558	2.1%
7	4402	2.0%
z	3521	1.6%
F	3477	1.6%
Other values (52)	175444	80.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	219428	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
5	4758	2.2%
3	4703	2.1%
2	4676	2.1%
0	4673	2.1%
4	4621	2.1%
1	4595	2.1%
6	4558	2.1%
7	4402	2.0%
z	3521	1.6%
F	3477	1.6%
Other values (52)	175444	80.0%

title
Text

Distinct	7816
Distinct (%)	78.4%
Missing	0
Missing (%)	0.0%
Memory size	771.6 KiB

Length

Max length	217
Median length	100
Mean length	19.813816
Min length	1

Characters and Unicode

Total characters	197623
Distinct characters	306
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7019 ?
Unique (%)	70.4%

Sample

1st row	Popular - From "Wicked" Original Broadway Cast Recording/2003
2nd row	Popular (with Playboi Carti & Madonna) - From The Idol Vol. 1 (Music from the HBO Original Series)
3rd row	Pop Muzik
4th row	Pop Out (feat. Lil Tjay)
5th row	Popular Monster

Value	Count	Frequency (%)
	1609	4.7%
the	1083	3.1%
rock	870	2.5%
jazz	522	1.5%
hard	454	1.3%
electronic	425	1.2%
disco	420	1.2%
holidays	399	1.2%
from	352	1.0%
pop	349	1.0%
Other values (6912)	27929	81.2%

Most occurring characters

Value	Count	Frequency (%)
	24438	12.4%
e	15344	7.8%
o	13138	6.6%
a	11983	6.1%
i	11031	5.6%
n	9178	4.6%
r	8993	4.6%
t	8687	4.4%
s	7112	3.6%
l	6360	3.2%
Other values (296)	81359	41.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	197623	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	24438	12.4%
e	15344	7.8%
o	13138	6.6%
a	11983	6.1%
i	11031	5.6%
n	9178	4.6%
r	8993	4.6%
t	8687	4.4%
s	7112	3.6%
l	6360	3.2%
Other values (296)	81359	41.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	197623	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	24438	12.4%
e	15344	7.8%
o	13138	6.6%
a	11983	6.1%
i	11031	5.6%
n	9178	4.6%
r	8993	4.6%
t	8687	4.4%
s	7112	3.6%
l	6360	3.2%
Other values (296)	81359	41.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	197623	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	24438	12.4%
e	15344	7.8%
o	13138	6.6%
a	11983	6.1%
i	11031	5.6%
n	9178	4.6%
r	8993	4.6%
t	8687	4.4%
s	7112	3.6%
l	6360	3.2%
Other values (296)	81359	41.2%

artist_name
Text

Distinct	5150
Distinct (%)	51.6%
Missing	0
Missing (%)	0.0%
Memory size	680.4 KiB

Length

Max length	61
Median length	43
Mean length	11.880188
Min length	1

Characters and Unicode

Total characters	118493
Distinct characters	213
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3887 ?
Unique (%)	39.0%

Sample

1st row	Stephen Schwartz
2nd row	The Weeknd
3rd row	M
4th row	Polo G
5th row	Falling In Reverse

Value	Count	Frequency (%)
the	500	2.6%
death	333	1.7%
electronic	311	1.6%
music	271	1.4%
jazz	235	1.2%
anime	153	0.8%
of	150	0.8%
metal	130	0.7%
kato	127	0.7%
moonlight	114	0.6%
Other values (6405)	17024	88.0%

Most occurring characters

Value	Count	Frequency (%)
e	10018	8.5%
	9375	7.9%
a	8769	7.4%
i	7416	6.3%
o	7237	6.1%
n	6247	5.3%
r	5875	5.0%
t	5256	4.4%
l	4778	4.0%
s	4758	4.0%
Other values (203)	48764	41.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	118493	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	10018	8.5%
	9375	7.9%
a	8769	7.4%
i	7416	6.3%
o	7237	6.1%
n	6247	5.3%
r	5875	5.0%
t	5256	4.4%
l	4778	4.0%
s	4758	4.0%
Other values (203)	48764	41.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	118493	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	10018	8.5%
	9375	7.9%
a	8769	7.4%
i	7416	6.3%
o	7237	6.1%
n	6247	5.3%
r	5875	5.0%
t	5256	4.4%
l	4778	4.0%
s	4758	4.0%
Other values (203)	48764	41.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	118493	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	10018	8.5%
	9375	7.9%
a	8769	7.4%
i	7416	6.3%
o	7237	6.1%
n	6247	5.3%
r	5875	5.0%
t	5256	4.4%
l	4778	4.0%
s	4758	4.0%
Other values (203)	48764	41.2%

album_name
Text

Distinct	6276
Distinct (%)	62.9%
Missing	0
Missing (%)	0.0%
Memory size	782.4 KiB

Length

Max length	217
Median length	98
Mean length	21.383497
Min length	1

Characters and Unicode

Total characters	213279
Distinct characters	334
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5242 ?
Unique (%)	52.6%

Sample

1st row	Wicked (Original Broadway Cast Recording / Deluxe Edition)
2nd row	Popular (Music from the HBO Original Series)
3rd row	Pop Muzik
4th row	Die A Legend
5th row	Popular Monster

Value	Count	Frequency (%)
the	1284	3.6%
	909	2.6%
anime	701	2.0%
indie	597	1.7%
jazz	591	1.7%
rock	589	1.7%
of	462	1.3%
christmas	405	1.1%
vol	403	1.1%
for	400	1.1%
Other values (6354)	29294	82.2%

Most occurring characters

Value	Count	Frequency (%)
	25661	12.0%
e	17425	8.2%
o	13084	6.1%
i	12846	6.0%
a	11704	5.5%
n	10172	4.8%
t	9687	4.5%
r	9121	4.3%
s	8670	4.1%
l	7696	3.6%
Other values (324)	87213	40.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	213279	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	25661	12.0%
e	17425	8.2%
o	13084	6.1%
i	12846	6.0%
a	11704	5.5%
n	10172	4.8%
t	9687	4.5%
r	9121	4.3%
s	8670	4.1%
l	7696	3.6%
Other values (324)	87213	40.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	213279	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	25661	12.0%
e	17425	8.2%
o	13084	6.1%
i	12846	6.0%
a	11704	5.5%
n	10172	4.8%
t	9687	4.5%
r	9121	4.3%
s	8670	4.1%
l	7696	3.6%
Other values (324)	87213	40.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	213279	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	25661	12.0%
e	17425	8.2%
o	13084	6.1%
i	12846	6.0%
a	11704	5.5%
n	10172	4.8%
t	9687	4.5%
r	9121	4.3%
s	8670	4.1%
l	7696	3.6%
Other values (324)	87213	40.9%

release_date
Date

Distinct	2903
Distinct (%)	29.1%
Missing	0
Missing (%)	0.0%
Memory size	78.1 KiB

Minimum	1942-01-01 00:00:00
Maximum	2024-11-23 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

duration_ms
Real number (ℝ)

Distinct	8397
Distinct (%)	84.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	196648.14

Minimum	30014
Maximum	3600014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.1 KiB

Quantile statistics

Minimum	30014
5-th percentile	79979.5
Q1	138441.75
median	187113
Q3	234878.25
95-th percentile	343323.65
Maximum	3600014
Range	3570000
Interquartile range (IQR)	96436.5

Descriptive statistics

Standard deviation	100651.6
Coefficient of variation (CV)	0.51183603
Kurtosis	183.47249
Mean	196648.14
Median Absolute Deviation (MAD)	48280
Skewness	7.5140319
Sum	1.9613685 × 10⁹
Variance	1.0130745 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
120000	31	0.3%
94534	26	0.3%
192000	13	0.1%
204000	13	0.1%
156000	12	0.1%
144000	12	0.1%
138000	12	0.1%
240000	11	0.1%
128000	11	0.1%
132000	10	0.1%
Other values (8387)	9823	98.5%

Value	Count	Frequency (%)
30014	1	< 0.1%
30066	1	< 0.1%
30232	1	< 0.1%
30750	1	< 0.1%
32261	1	< 0.1%
32653	1	< 0.1%
32810	1	< 0.1%
32933	1	< 0.1%
33040	1	< 0.1%
33973	1	< 0.1%

Value	Count	Frequency (%)
3600014	1	< 0.1%
2575000	1	< 0.1%
1800020	1	< 0.1%
1723500	1	< 0.1%
1510272	1	< 0.1%
1500004	1	< 0.1%
1179814	1	< 0.1%
1074720	1	< 0.1%
1046000	1	< 0.1%
990600	1	< 0.1%

genre
Categorical

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	617.9 KiB

hard-rock	1055
Electronic	1017
pop	998
jazz	997
rock	996
Other values (5)	4911

Length

Max length	11
Median length	9
Mean length	6.4208943
Min length	3

Characters and Unicode

Total characters	64042
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	pop
2nd row	pop
3rd row	pop
4th row	pop
5th row	pop

Common Values

Value	Count	Frequency (%)
hard-rock	1055	10.6%
Electronic	1017	10.2%
pop	998	10.0%
jazz	997	10.0%
rock	996	10.0%
disco	994	10.0%
holidays	994	10.0%
Indie	986	9.9%
death-metal	979	9.8%
anime	958	9.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
hard-rock	1055	10.6%
electronic	1017	10.2%
pop	998	10.0%
jazz	997	10.0%
rock	996	10.0%
disco	994	10.0%
holidays	994	10.0%
indie	986	9.9%
death-metal	979	9.8%
anime	958	9.6%

Most occurring characters

Value	Count	Frequency (%)
o	6054	9.5%
a	5962	9.3%
c	5079	7.9%
d	5008	7.8%
i	4949	7.7%
e	4919	7.7%
r	4123	6.4%
h	3028	4.7%
l	2990	4.7%
t	2975	4.6%
Other values (11)	18955	29.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	64042	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	6054	9.5%
a	5962	9.3%
c	5079	7.9%
d	5008	7.8%
i	4949	7.7%
e	4919	7.7%
r	4123	6.4%
h	3028	4.7%
l	2990	4.7%
t	2975	4.6%
Other values (11)	18955	29.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	64042	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	6054	9.5%
a	5962	9.3%
c	5079	7.9%
d	5008	7.8%
i	4949	7.7%
e	4919	7.7%
r	4123	6.4%
h	3028	4.7%
l	2990	4.7%
t	2975	4.6%
Other values (11)	18955	29.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	64042	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	6054	9.5%
a	5962	9.3%
c	5079	7.9%
d	5008	7.8%
i	4949	7.7%
e	4919	7.7%
r	4123	6.4%
h	3028	4.7%
l	2990	4.7%
t	2975	4.6%
Other values (11)	18955	29.6%

danceability
Real number (ℝ)

Distinct	877
Distinct (%)	8.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.57720249

Minimum	0
Maximum	0.985
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	78.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.242
Q1	0.45725
median	0.595
Q3	0.714
95-th percentile	0.844
Maximum	0.985
Range	0.985
Interquartile range (IQR)	0.25675

Descriptive statistics

Standard deviation	0.18174192
Coefficient of variation (CV)	0.31486683
Kurtosis	-0.414634
Mean	0.57720249
Median Absolute Deviation (MAD)	0.127
Skewness	-0.38199322
Sum	5757.0176
Variance	0.033030125
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.772	34	0.3%
0.622	34	0.3%
0.67	33	0.3%
0.549	32	0.3%
0.705	31	0.3%
0.719	30	0.3%
0.559	30	0.3%
0.654	29	0.3%
0.588	29	0.3%
0.602	29	0.3%
Other values (867)	9663	96.9%

Value	Count	Frequency (%)
0	4	< 0.1%
0.0589	1	< 0.1%
0.0608	1	< 0.1%
0.061	1	< 0.1%
0.0625	1	< 0.1%
0.0653	1	< 0.1%
0.0658	1	< 0.1%
0.0666	1	< 0.1%
0.0693	2	< 0.1%
0.0696	1	< 0.1%

Value	Count	Frequency (%)
0.985	1	< 0.1%
0.983	1	< 0.1%
0.978	2	< 0.1%
0.977	1	< 0.1%
0.974	1	< 0.1%
0.969	1	< 0.1%
0.967	1	< 0.1%
0.965	1	< 0.1%
0.962	3	< 0.1%
0.959	1	< 0.1%

energy
Real number (ℝ)

High correlation

Distinct	1467
Distinct (%)	14.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.59921966

Minimum	1.92 × 10^-5
Maximum	1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.1 KiB

Quantile statistics

Minimum	1.92 × 10^-5
5-th percentile	0.054095
Q1	0.378
median	0.652
Q3	0.856
95-th percentile	0.973
Maximum	1
Range	0.9999808
Interquartile range (IQR)	0.478

Descriptive statistics

Standard deviation	0.29160843
Coefficient of variation (CV)	0.48664698
Kurtosis	-0.93771848
Mean	0.59921966
Median Absolute Deviation (MAD)	0.227
Skewness	-0.48294269
Sum	5976.6169
Variance	0.085035479
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.973	28	0.3%
0.962	28	0.3%
0.977	28	0.3%
0.988	27	0.3%
0.923	27	0.3%
0.938	27	0.3%
0.892	26	0.3%
0.943	26	0.3%
0.978	26	0.3%
0.947	25	0.3%
Other values (1457)	9706	97.3%

Value	Count	Frequency (%)
1.92 × 10^-5	1	< 0.1%
2.02 × 10^-5	1	< 0.1%
2.03 × 10^-5	1	< 0.1%
0.000272	1	< 0.1%
0.000545	1	< 0.1%
0.000884	1	< 0.1%
0.00144	1	< 0.1%
0.00146	1	< 0.1%
0.00177	1	< 0.1%
0.00225	1	< 0.1%

Value	Count	Frequency (%)
1	2	< 0.1%
0.999	9	0.1%
0.998	11	0.1%
0.997	14	0.1%
0.996	13	0.1%
0.995	19	0.2%
0.994	15	0.2%
0.993	22	0.2%
0.992	11	0.1%
0.991	22	0.2%

key
Real number (ℝ)

Zeros

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.1763585

Minimum	0
Maximum	11
Zeros	1198
Zeros (%)	12.0%
Negative	0
Negative (%)	0.0%
Memory size	78.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	8
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.6115225
Coefficient of variation (CV)	0.69769559
Kurtosis	-1.308966
Mean	5.1763585
Median Absolute Deviation (MAD)	3
Skewness	0.051938237
Sum	51629
Variance	13.043095
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	1198	12.0%
1	1110	11.1%
7	1070	10.7%
2	1043	10.5%
9	930	9.3%
11	851	8.5%
5	797	8.0%
4	714	7.2%
6	713	7.1%
8	647	6.5%
Other values (2)	901	9.0%

Value	Count	Frequency (%)
0	1198	12.0%
1	1110	11.1%
2	1043	10.5%
3	299	3.0%
4	714	7.2%
5	797	8.0%
6	713	7.1%
7	1070	10.7%
8	647	6.5%
9	930	9.3%

Value	Count	Frequency (%)
11	851	8.5%
10	602	6.0%
9	930	9.3%
8	647	6.5%
7	1070	10.7%
6	713	7.1%
5	797	8.0%
4	714	7.2%
3	299	3.0%
2	1043	10.5%

loudness
Real number (ℝ)

High correlation

Distinct	7393
Distinct (%)	74.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-10.50441

Minimum	-46.986
Maximum	0.642
Zeros	0
Zeros (%)	0.0%
Negative	9968
Negative (%)	99.9%
Memory size	78.1 KiB

Quantile statistics

Minimum	-46.986
5-th percentile	-25.26835
Q1	-13.14175
median	-8.3995
Q3	-5.73
95-th percentile	-3.45925
Maximum	0.642
Range	47.628
Interquartile range (IQR)	7.41175

Descriptive statistics

Standard deviation	6.9310808
Coefficient of variation (CV)	-0.6598258
Kurtosis	2.9764394
Mean	-10.50441
Median Absolute Deviation (MAD)	3.2395
Skewness	-1.6326722
Sum	-104770.99
Variance	48.039881
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-6.531	8	0.1%
-5.327	7	0.1%
-4.701	7	0.1%
-6.502	7	0.1%
-5.423	7	0.1%
-8.452	7	0.1%
-5.411	6	0.1%
-6.441	6	0.1%
-8.698	6	0.1%
-7.743	6	0.1%
Other values (7383)	9907	99.3%

Value	Count	Frequency (%)
-46.986	1	< 0.1%
-46.979	1	< 0.1%
-44.85	1	< 0.1%
-43.484	1	< 0.1%
-43.082	1	< 0.1%
-42.924	1	< 0.1%
-42.717	1	< 0.1%
-42.686	1	< 0.1%
-42.593	1	< 0.1%
-42.38	1	< 0.1%

Value	Count	Frequency (%)
0.642	1	< 0.1%
0.58	1	< 0.1%
0.461	1	< 0.1%
0.421	1	< 0.1%
0.03	1	< 0.1%
0.024	1	< 0.1%
-0.002	1	< 0.1%
-0.016	1	< 0.1%
-0.436	1	< 0.1%
-0.463	1	< 0.1%

tempo
Real number (ℝ)

High correlation

Distinct	8268
Distinct (%)	82.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	121.37747

Minimum	0
Maximum	220.01
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	78.1 KiB

Quantile statistics

Minimum	0
5-th percentile	75.5042
Q1	99.06275
median	120.982
Q3	140.016
95-th percentile	174.9164
Maximum	220.01
Range	220.01
Interquartile range (IQR)	40.95325

Descriptive statistics

Standard deviation	30.005565
Coefficient of variation (CV)	0.24720868
Kurtosis	-0.24904331
Mean	121.37747
Median Absolute Deviation (MAD)	20.9545
Skewness	0.25052304
Sum	1210618.9
Variance	900.33393
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
119.996	9	0.1%
127.987	8	0.1%
119.987	8	0.1%
120.023	8	0.1%
120.006	7	0.1%
130.014	7	0.1%
120.012	7	0.1%
120	7	0.1%
119.993	6	0.1%
127.968	6	0.1%
Other values (8258)	9901	99.3%

Value	Count	Frequency (%)
0	4	< 0.1%
36.015	1	< 0.1%
36.336	1	< 0.1%
39.72	1	< 0.1%
39.769	1	< 0.1%
42.78	1	< 0.1%
43.84	1	< 0.1%
44.07	1	< 0.1%
45.466	1	< 0.1%
47.523	1	< 0.1%

Value	Count	Frequency (%)
220.01	1	< 0.1%
216.185	1	< 0.1%
215.796	1	< 0.1%
213.055	1	< 0.1%
212.192	2	< 0.1%
212.108	1	< 0.1%
210.983	1	< 0.1%
210.222	1	< 0.1%
209.964	1	< 0.1%
209.364	1	< 0.1%

time_signature
Categorical

High correlation Imbalance

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	565.1 KiB

4	8922
3	815
5	161
1	72
0	4

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	9974
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	4
4th row	4
5th row	4

Common Values

Value	Count	Frequency (%)
4	8922	89.5%
3	815	8.2%
5	161	1.6%
1	72	0.7%
0	4	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4	8922	89.5%
3	815	8.2%
5	161	1.6%
1	72	0.7%
0	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
4	8922	89.5%
3	815	8.2%
5	161	1.6%
1	72	0.7%
0	4	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9974	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	8922	89.5%
3	815	8.2%
5	161	1.6%
1	72	0.7%
0	4	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9974	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	8922	89.5%
3	815	8.2%
5	161	1.6%
1	72	0.7%
0	4	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9974	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	8922	89.5%
3	815	8.2%
5	161	1.6%
1	72	0.7%
0	4	< 0.1%

instrumentalness
Real number (ℝ)

Zeros

Distinct	2798
Distinct (%)	28.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.35490101

Minimum	0
Maximum	0.998
Zeros	2102
Zeros (%)	21.1%
Negative	0
Negative (%)	0.0%
Memory size	78.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4.9525 × 10^-6
median	0.03405
Q3	0.846
95-th percentile	0.947
Maximum	0.998
Range	0.998
Interquartile range (IQR)	0.84599505

Descriptive statistics

Standard deviation	0.40815394
Coefficient of variation (CV)	1.1500501
Kurtosis	-1.6718531
Mean	0.35490101
Median Absolute Deviation (MAD)	0.03405
Skewness	0.43918755
Sum	3539.7827
Variance	0.16658964
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2102	21.1%
0.924	35	0.4%
0.883	30	0.3%
0.944	30	0.3%
0.917	29	0.3%
0.945	28	0.3%
0.916	28	0.3%
0.902	28	0.3%
0.9	27	0.3%
0.915	27	0.3%
Other values (2788)	7610	76.3%

Value	Count	Frequency (%)
0	2102	21.1%
1 × 10^-6	2	< 0.1%
1.01 × 10^-6	4	< 0.1%
1.02 × 10^-6	4	< 0.1%
1.03 × 10^-6	3	< 0.1%
1.04 × 10^-6	2	< 0.1%
1.05 × 10^-6	2	< 0.1%
1.06 × 10^-6	1	< 0.1%
1.07 × 10^-6	3	< 0.1%
1.08 × 10^-6	1	< 0.1%

Value	Count	Frequency (%)
0.998	2	< 0.1%
0.995	1	< 0.1%
0.992	4	< 0.1%
0.991	2	< 0.1%
0.989	1	< 0.1%
0.988	1	< 0.1%
0.987	2	< 0.1%
0.986	1	< 0.1%
0.985	2	< 0.1%
0.984	2	< 0.1%

liveness
Real number (ℝ)

Distinct	1312
Distinct (%)	13.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.19276613

Minimum	0.0114
Maximum	0.991
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.1 KiB

Quantile statistics

Minimum	0.0114
5-th percentile	0.0617
Q1	0.0983
median	0.122
Q3	0.242
95-th percentile	0.53635
Maximum	0.991
Range	0.9796
Interquartile range (IQR)	0.1437

Descriptive statistics

Standard deviation	0.16152324
Coefficient of variation (CV)	0.83792335
Kurtosis	5.8223742
Mean	0.19276613
Median Absolute Deviation (MAD)	0.0402
Skewness	2.2655299
Sum	1922.6494
Variance	0.026089758
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.11	150	1.5%
0.108	147	1.5%
0.111	147	1.5%
0.112	146	1.5%
0.109	140	1.4%
0.106	133	1.3%
0.107	122	1.2%
0.104	120	1.2%
0.105	115	1.2%
0.102	110	1.1%
Other values (1302)	8644	86.7%

Value	Count	Frequency (%)
0.0114	1	< 0.1%
0.0116	1	< 0.1%
0.0146	1	< 0.1%
0.016	2	< 0.1%
0.0161	1	< 0.1%
0.0182	1	< 0.1%
0.0211	1	< 0.1%
0.0212	2	< 0.1%
0.0216	1	< 0.1%
0.0227	1	< 0.1%

Value	Count	Frequency (%)
0.991	1	< 0.1%
0.989	1	< 0.1%
0.98	2	< 0.1%
0.979	1	< 0.1%
0.975	2	< 0.1%
0.972	1	< 0.1%
0.971	1	< 0.1%
0.969	3	< 0.1%
0.966	1	< 0.1%
0.965	2	< 0.1%

valence
Real number (ℝ)

Distinct	1324
Distinct (%)	13.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.46544624

Minimum	0
Maximum	1
Zeros	9
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	78.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0685
Q1	0.246
median	0.452
Q3	0.67275
95-th percentile	0.912
Maximum	1
Range	1
Interquartile range (IQR)	0.42675

Descriptive statistics

Standard deviation	0.26106665
Coefficient of variation (CV)	0.56089539
Kurtosis	-1.0291006
Mean	0.46544624
Median Absolute Deviation (MAD)	0.214
Skewness	0.16397973
Sum	4642.3608
Variance	0.068155798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.964	25	0.3%
0.276	24	0.2%
0.962	22	0.2%
0.961	22	0.2%
0.394	22	0.2%
0.175	22	0.2%
0.23	22	0.2%
0.671	22	0.2%
0.612	22	0.2%
0.156	21	0.2%
Other values (1314)	9750	97.8%

Value	Count	Frequency (%)
0	9	0.1%
1 × 10^-5	11	0.1%
0.00403	1	< 0.1%
0.0058	1	< 0.1%
0.0126	1	< 0.1%
0.0218	1	< 0.1%
0.0222	1	< 0.1%
0.0224	1	< 0.1%
0.0234	1	< 0.1%
0.0236	2	< 0.1%

Value	Count	Frequency (%)
1	3	< 0.1%
0.989	1	< 0.1%
0.987	1	< 0.1%
0.985	1	< 0.1%
0.984	1	< 0.1%
0.983	1	< 0.1%
0.981	3	< 0.1%
0.98	1	< 0.1%
0.979	1	< 0.1%
0.978	1	< 0.1%

	danceability	duration_ms	energy	genre	instrumentalness	key	liveness	loudness	tempo	time_signature	valence
danceability	1.000	-0.141	-0.143	0.176	-0.134	0.039	-0.157	-0.022	-0.022	0.207	0.421
duration_ms	-0.141	1.000	0.362	0.044	-0.190	0.012	0.051	0.343	0.026	0.000	-0.010
energy	-0.143	0.362	1.000	0.247	-0.262	0.041	0.215	0.796	0.213	0.127	0.167
genre	0.176	0.044	0.247	1.000	0.173	0.039	0.068	0.205	0.096	0.066	0.111
instrumentalness	-0.134	-0.190	-0.262	0.173	1.000	-0.015	-0.171	-0.495	-0.079	0.058	-0.295
key	0.039	0.012	0.041	0.039	-0.015	1.000	-0.000	0.023	0.007	0.016	0.038
liveness	-0.157	0.051	0.215	0.068	-0.171	-0.000	1.000	0.189	0.026	0.029	0.003
loudness	-0.022	0.343	0.796	0.205	-0.495	0.023	0.189	1.000	0.169	0.115	0.230
tempo	-0.022	0.026	0.213	0.096	-0.079	0.007	0.026	0.169	1.000	0.505	0.103
time_signature	0.207	0.000	0.127	0.066	0.058	0.016	0.029	0.115	0.505	1.000	0.086
valence	0.421	-0.010	0.167	0.111	-0.295	0.038	0.003	0.230	0.103	0.086	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	song_id	title	artist_name	album_name	release_date	duration_ms	genre	danceability	energy	key	loudness	tempo	time_signature	instrumentalness	liveness	valence
0	57Pk2GU0ABFYBbbcgYxqki	Popular - From "Wicked" Original Broadway Cast Recording/2003	Stephen Schwartz	Wicked (Original Broadway Cast Recording / Deluxe Edition)	2013-01-01	224386	pop	0.711	0.228	0	-12.850	88.714	4	0.000000	0.1220	0.548
1	6WzRpISELf3YglGAh7TXcG	Popular (with Playboi Carti & Madonna) - From The Idol Vol. 1 (Music from the HBO Original Series)	The Weeknd	Popular (Music from the HBO Original Series)	2023-06-02	215466	pop	0.854	0.674	1	-6.230	99.022	4	0.000085	0.5090	0.848
2	6z3HAUZpAyJ0ctsbAwAiw3	Pop Muzik	M	Pop Muzik	2022-06-03	200682	pop	0.935	0.833	1	-7.493	108.914	4	0.000016	0.0792	0.967
3	6uFn47ACjqYkc0jADwEdj1	Pop Out (feat. Lil Tjay)	Polo G	Die A Legend	2019-06-07	166560	pop	0.772	0.639	1	-7.119	168.112	4	0.000000	0.0698	0.261
4	4GssB27iJeqmfGxS94Tfij	Popular Monster	Falling In Reverse	Popular Monster	2019-11-20	220537	pop	0.461	0.897	3	-3.982	165.107	4	0.000000	0.0965	0.358
5	4myFsmx2v6znDOJfn3IkbD	Popular Monster	Falling In Reverse	Popular Monster	2024-08-16	220537	pop	0.461	0.898	3	-3.982	165.079	4	0.000000	0.0963	0.353
6	6AviHKu3ydzAePBmzEi62v	Popular Song	MIKA	Yours Truly	2013-01-01	200213	pop	0.666	0.810	8	-4.574	99.023	4	0.000000	0.0613	0.811
7	79s5XnCN4TJKTVMSmOx8Ep	Dior	Pop Smoke	Meet The Woo	2019-07-26	216386	pop	0.548	0.805	7	-5.732	142.096	4	0.000405	0.4080	0.649
8	3wn8nOygkHLUQ9dlXM1rKW	Poppin	Yeat	2 Alivë	2022-02-18	167186	pop	0.705	0.613	7	-7.441	74.521	4	0.000007	0.1980	0.259
9	0widrZ6KVNuIPhbM1rWPDR	Pop Star	Coco & Clair Clair	Sexy	2022-11-04	184222	pop	0.891	0.670	0	-7.256	128.046	4	0.002730	0.1100	0.938

	song_id	title	artist_name	album_name	release_date	duration_ms	genre	danceability	energy	key	loudness	tempo	time_signature	instrumentalness	liveness	valence
9964	260h0j3EoZYsOnnlEzY6vo	Spider Dance Anime Opening	Thai McGrath	Spider Dance Anime Opening	2024-04-13	187431	anime	0.623	0.9700	1	-3.658	105.047	4	0.000	0.313	0.7320
9965	1u3jNRvccJexSiHvEwRkZm	Kuno	Anime Moonlight	Death Note	2024-06-19	109367	anime	0.765	0.2740	7	-13.028	79.006	4	0.924	0.158	0.3350
9966	1wCn6xWvFFtY86zcw9LIX4	Moonlight in Kyoto	Anime Moonlight	Moonlight Destination	2024-08-02	111428	anime	0.683	0.3060	0	-11.312	140.103	4	0.791	0.126	0.0565
9967	4WefBsWnKnKsx1MxThJjOC	Akane's Sayoonara Call	ChillHoop	Anime Moonlight Vol. 2	2024-07-12	99230	anime	0.670	0.3960	4	-14.666	156.007	5	0.929	0.171	0.5230
9968	1g1hJuLAssI47Gb5V2yBCT	Apollon Blue (From "Sakamichi No Apollon") - Piano Version	Atsumi Miko	Anime Piano Sleep	2023-06-16	93857	anime	0.437	0.0212	3	-26.735	70.850	4	0.941	0.104	0.3070
9969	4FmUrmRianI41BlO2RYhew	She Was Here, Alone (From "Erased")	LucasPianoRoom	Anime Piano, Vol. 2	2020-04-02	140945	anime	0.442	0.0593	4	-19.093	62.987	3	0.951	0.155	0.1080
9970	45YTUUPFSm6GS6LsddwRmj	Beautiful World (From "Darling in the FranXX")	Fonzi M	Anime Piano Music Collection in Spring, Vol. 2	2018-04-20	92282	anime	0.517	0.3640	4	-16.545	131.958	4	0.964	0.230	0.7260
9971	1DXSEjzzL5x9TybrYE2A3K	Eminent (Soundtrack from the Anime "Black Butler Book" of the Atlantic)	Rolelush	Anime and Game on Piano	2018-12-03	80039	anime	0.323	0.1690	2	-23.435	117.083	4	0.844	0.212	0.0954
9972	1E65lXfTCueQizuL4z8knx	A Silent Voice- Lit var - Koe no Katachi	Otaku Muisc	Opening Triste ,Vol.1	2022-04-11	150932	anime	0.386	0.0448	7	-19.892	88.128	3	0.958	0.103	0.0729
9973	1fDkKDjiAgVn3uQPpvdAPx	Nabiki's Letter to Peace	ChillHoop	Anime Moonlight Vol. 2	2024-07-12	99000	anime	0.706	0.1920	9	-18.031	79.990	4	0.168	0.307	0.3240

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample